<?php
	header("Content-Type:text/html;charset=utf-8"); 
	include '../dbConfig/mysqlFun.php';
	$mysqlDB = new mysqlFun();
	$allTableName = $mysqlDB->getAllTableName();
?>
<link rel="stylesheet" type="text/css" href="css/common.css"/>
<script type="text/javascript" src="jquery/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="js/selectCheckBox.js"></script>
<script type="text/javascript" src="js/formAction.js"></script>
<form action="truncateMysql.php" method="post" name="actionForm" id="actionForm" enctype="multipart/form-data">
	<div id='tableNameList'>
<?php 
	foreach($allTableName as $key=>$tableName){
?>
		<div class='tableName'>
			<input type="checkbox" name="tableName[]" class="tableNameCheckBox" value="<?php echo $tableName; ?>" />
			<span><?php echo $tableName; ?></span>
		</div>
<?php
	}
?>
	</div>
	<div id="btnAction">
		<input type="hidden" name="allSelectAction" id="allSelectAction" value="no" />
		<input type="button" name="allSelect" id="allSelect" value="全选" />
	</div>
	<input type="submit" name="truncateSubmit" id="truncateSubmit" value="删除表数据" /><br>
	<input type="submit" name="exportExcelModelSubmit" id="exportExcelModelSubmit" value="导出指定表的批插入excel模板" /><br>
	<input type="submit" name="exportDBDateSubmit" id="exportDBDateSubmit" value="导出指定表的excel数据" /><br>
	<input type="file" name="importExcelFile" />
	<input type="submit" name="importExcelModelSubmit" id="importExcelModelSubmit" value="导入excel模板表数据" /><br>
</form>

<div id="tableDateList"></div>